CREATE TABLE [dbo].[Participate]
(
[MemberId] [int] NOT NULL,
[EventId] [int] NOT NULL,
[PositionId] [int] NOT NULL,
[CommitteeId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Participate] ADD CONSTRAINT [FK_Participate_Committee] FOREIGN KEY ([CommitteeId]) REFERENCES [dbo].[Committee] ([Id])
GO
ALTER TABLE [dbo].[Participate] ADD CONSTRAINT [FK_Participate_Event] FOREIGN KEY ([EventId]) REFERENCES [dbo].[Event] ([Id])
GO
ALTER TABLE [dbo].[Participate] ADD CONSTRAINT [FK_Participate_Member] FOREIGN KEY ([MemberId]) REFERENCES [dbo].[Member] ([Id])
GO
ALTER TABLE [dbo].[Participate] ADD CONSTRAINT [FK_Participate_PositionType] FOREIGN KEY ([PositionId]) REFERENCES [dbo].[Position] ([Id])
GO
